package com.caimiao.miao.library.database.table;

public class DeviceTable {
    public static String _ID = "id";
    public static String ATTR_DEVICE = "device";
    public static String ATTR_BATTERY = "battery";
    public static String ATTR_NET = "net";
    public static String ATTR_LAT = "lat";
    public static String ATTR_LNG = "lng";
    public static String ATTR_LOC_TYPE = "locType";
    public static String ATTR_ONLINE = "online";

    public static String TABLE_NAME = "DEVICE_INFO";
    public static String CREATE_SQL = "create table " + TABLE_NAME + " ("
            + _ID + " integer primary key autoincrement, "
            + ATTR_DEVICE + " text not null, "
            + ATTR_BATTERY + " text not null, "
            + ATTR_NET + " text not null, "
            + ATTR_LAT + " real not null, "
            + ATTR_LNG + " real not null, "
            + ATTR_LOC_TYPE + " text not null, "
            + ATTR_ONLINE + " text"
            + ");";
}
